from common.mysql.MySQLhelper import get_sql_helper

sqlhelper = get_sql_helper()


def insert_service_manager_by_value(id01, today, user_id, nick_name, chat_type, apply_code, apply_name):
    sqlhelper.insert_one(
        "INSERT INTO shequn_service_manager (id, create_time, user_id, user_name, chat_type, apply_code, apply_name) VALUES(%s, %s, %s, %s, %s, %s, %s); ",
        (id01, today, user_id, nick_name, chat_type, apply_code, apply_name))

def delete_service_manager(user_id):
    sqlhelper.delete("DELETE from shequn_service_manager where user_id = %s;", (user_id))